`SELECT MIN(ZoneMin), MAX(ZoneMin) FROM Plant` as LINQ to SQL?
To achieve the same performance as your original query, you'll need to use grouping (by a constant to minimize impact, e. G 0 ), so that you can refer to the same set of records twice in the same query. Using the table name causes a new query to be produced on each reference.
Try the following: (from plant in db. Plants group plant by 0 into plants select new { Min = plants. Min(p => p.
ZoneMin), Max = plants. Max(p => p. ZoneMin) } ).Single() This produces the following query: SELECT MIN(plants.
ZoneMin), MAX(plants. ZoneMin) FROM (SELECT 0 AS Grp, ZoneMin FROM Plants) AS plants GROUP BY plants. Grp And after the optimizer is done with it, it spits out something equivalent to your query, at least according to SQL Server Management Studio.
To achieve the same performance as your original query, you'll need to use grouping (by a constant to minimize impact, e.g. 0), so that you can refer to the same set of records twice in the same query. Using the table name causes a new query to be produced on each reference. Try the following: (from plant in db.
Plants group plant by 0 into plants select new { Min = plants. Min(p => p. ZoneMin), Max = plants.
Max(p => p. ZoneMin) } ).Single() This produces the following query: SELECT MIN(plants. ZoneMin), MAX(plants.
ZoneMin) FROM (SELECT 0 AS Grp, ZoneMin FROM Plants) AS plants GROUP BY plants. Grp And after the optimizer is done with it, it spits out something equivalent to your query, at least according to SQL Server Management Studio.
Nicely done! Thank you Allon. I tend to forget to try the "group by a constant" trick.
– Peter Jan 14 at 14:56 @Peter: Then you're ahead of me - I haven't even heard of this trick before researching your question. – Allon Guralnek Jan 14 at 19:44.
This rather simple SQL query is proving to be quite perplexing when attempting it from LINQ. I have a SQL table Plant with column ZoneMin. I want to find the minimum and maximum of the values in the column. What's a LINQ query that could get me to this (or some similar) SQL?
I've made various attempts at .Aggregate() and .GroupBy() with no luck. I've also looked at several SO questions that seem similar. This could be simply achieved with methods applied to a resulting array, but I shouldn't need to transport a value from every SQL row when it's so simple in T-SQL.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
How to build a sql query to return avg(price), min(price), max(price) joined with avg(order), min(order), max(order)?
How to Select Min and Max date values in Linq Query?
Flex clarification needed: width, min(max)Width, explicitWidth, explicitMin(Max)Width, measuredWidth, measuredMinWidth, percentWidth?
LINQ find max/min value with corresponding time fields?
LINQ LEFT OUTER JOIN, WHERE & MIN/MAX/Count difficulty?
Linq (MIN && MAX)?